SQLDIRECT("USE SESSION 3");
SQLPREPARE("DECLARE C3 CURSOR FOR");
SQLPREPARE("SELECT TOP 100 * FROM myJavaTABLE");
SQLEXECUTE();

SQLDIRECT ("OPEN C3");

var i;
for (i=0;i<=99;i++) {

SETVAL("index(" + i + ")=" + i);
SQLDIRECT("FETCH NEXT C3 INTO array1("+i+"), array2("+i+"), array3("+i+"), array4("+i+")");
//BWSPOOL("FETCH NEXT C3 INTO array1("+i+"), array2("+i+"), array3("+i+"), array4("+i+")");
}

//BWSPOOL "<before close>"
SQLDIRECT("CLOSE C3");
SETVAL("SQLSTATE=SELECT");
